Fully Qualified Name: | Laminas\Db\Sql\Platform\Mysql\SelectDecorator |
Extends: | Select |
Implements: | PlatformDecoratorInterface |
Name | Description | Defined By |
---|---|---|
__clone() | __clone | Select |
__construct() | Constructor | Select |
__get() | Variable overloading | Select |
columns() | Specify columns from which to select | Select |
combine() | Select | |
from() | Create from clause | Select |
getRawState() | Select | |
getSqlString() | {@inheritDoc} | AbstractSql |
group() | Select | |
having() | Create having clause | Select |
isTableReadOnly() | Returns whether the table is read only or not. | Select |
join() | Create join clause | Select |
limit() | Select | |
offset() | Select | |
order() | Select | |
prepareStatement() | {@inheritDoc} | AbstractPreparableSql |
quantifier() | Select | |
reset() | Select | |
setSpecification() | Select | |
setSubject() | SelectDecorator | |
where() | Create where clause | Select |
__clone
Resets the where object each time the Select is cloned.
Returns: void
Constructor
Parameter Name | Type | Description |
---|---|---|
$table | null|string|array|\TableIdentifier |
Returns:
Variable overloading
Parameter Name | Type | Description |
---|---|---|
$name | string |
Returns: mixed
Specify columns from which to select
Possible valid states:
array(*)
array(value, ...) value can be strings or Expression objects
array(string => value, ...) key string will be use as alias, value can be string or Expression objects
Parameter Name | Type | Description |
---|---|---|
$columns | array | |
$prefixColumnsWithTable | bool |
Returns: self Provides a fluent interface
Parameter Name | Type | Description |
---|---|---|
$select | \Select | |
$type | string | |
$modifier | string |
Returns: self Provides a fluent interface
Create from clause
Parameter Name | Type | Description |
---|---|---|
$table | string|array|\TableIdentifier |
Returns: self Provides a fluent interface
Parameter Name | Type | Description |
---|---|---|
$key |
Returns: void
{@inheritDoc}
Parameter Name | Type | Description |
---|---|---|
$adapterPlatform |
Returns:
Parameter Name | Type | Description |
---|---|---|
$group | mixed |
Returns: self Provides a fluent interface
Create having clause
Parameter Name | Type | Description |
---|---|---|
$predicate | \Where|\Closure|string|array | |
$combination | string | One |
Returns: self Provides a fluent interface
Returns whether the table is read only or not.
Returns: bool
Create join clause
Parameter Name | Type | Description |
---|---|---|
$name | string|array|\TableIdentifier | |
$on | string|\Predicate\Expression | |
$columns | string|array | |
$type | string | one |
Returns: self Provides a fluent interface
Parameter Name | Type | Description |
---|---|---|
$limit | int |
Returns: self Provides a fluent interface
Parameter Name | Type | Description |
---|---|---|
$offset | int |
Returns: self Provides a fluent interface
Parameter Name | Type | Description |
---|---|---|
$order | string|array|\Expression |
Returns: self Provides a fluent interface
{@inheritDoc}
Parameter Name | Type | Description |
---|---|---|
$adapter | ||
$statementContainer |
Returns: \StatementContainerInterface
Parameter Name | Type | Description |
---|---|---|
$quantifier | string|\Expression | DISTINCT|ALL |
Returns: self Provides a fluent interface
Parameter Name | Type | Description |
---|---|---|
$part | string |
Returns: self Provides a fluent interface
Parameter Name | Type | Description |
---|---|---|
$specification | ||
$index | ||
$specification |
Returns: self Provides a fluent interface
Parameter Name | Type | Description |
---|---|---|
$select | \Select |
Returns:
Create where clause
Parameter Name | Type | Description |
---|---|---|
$predicate | \Where|\Closure|string|array|\Predicate\PredicateInterface | |
$combination | string | One |
Returns: self Provides a fluent interface